Calls the stored procedures defined for a given package.
function ExecProcEx(Name: string; const Params: array of variant): variant;
Call the ExecProcEx method to call stored procedures defined for a given package. Name parameter is a name of a stored procedure.
If the sored procedure accepts or returns parameters, they must be supplied in the Params array as pairs of parameters' names and values so that every value would come immediately after its name. If the value for an input parameter was not included in the Params array, parameter default value is taken. If the parameter has no default value, NULL value is sent.
For example, the following is a stored procedure declaration in package DBMS_ALERT:
DBMS_ALERT.SIGNAL ( name IN VARCHAR2, message IN VARCHAR2);
it may be called by this code:
MyOraPackage.ExecProcEx("SIGNAL", ["name", "MySignalName", "message", "MyMessage"]);
It is different from the way ExecProc is used.